package com.eascs.ticket.ticket.service;

import org.springframework.stereotype.Service;

import com.eascs.app.dao.PageResult;
import com.eascs.app.dao.SqlPageQuery;
import com.eascs.ticket.common.service.BaseSevice;

@Service
public class TicketStatisticsService extends BaseSevice {

	public PageResult<Object[]> statOvertime() {
		SqlPageQuery<Object[]> sqlPageQuery = new SqlPageQuery<>(Object[].class, 1000000, 0);
		sqlPageQuery.setQuerySql("sql.stat.overtime");
		sqlPageQuery.setSumColumnIndexs(new int[] { 2 });
		return this.proxyDao.findDataWithPage(sqlPageQuery);
	}

	public PageResult<Object[]> statisticsUserTicket(SqlPageQuery<Object[]> sqlPageQuery) {
		return this.proxyDao.findDataWithPage(sqlPageQuery);
	}

}
